USE [RpcExtendService]
GO
INSERT [dbo].[AutoTaskList] ([Id], [RegionId], [RpcMerId], [TaskName], [TaskShow], [TaskPriority], [BeginStep], [FailEmall], [VerNum], [IsExec], [ExecVerNum], [LastExecTime], [LastExecEndTime], [NextExecTime], [TaskStatus], [StopTime]) VALUES (1, NULL, 1, N'分布式事务', N'1，检查超时事务 2，事务回滚重试', 0, 1, NULL, 0, 0, 1946139268, CAST(N'2024-04-11T21:13:35.000' AS DateTime), CAST(N'2024-04-11T21:13:35.000' AS DateTime), CAST(N'2024-04-11T21:13:45.000' AS DateTime), 1, NULL)
GO
INSERT [dbo].[AutoTaskList] ([Id], [RegionId], [RpcMerId], [TaskName], [TaskShow], [TaskPriority], [BeginStep], [FailEmall], [VerNum], [IsExec], [ExecVerNum], [LastExecTime], [LastExecEndTime], [NextExecTime], [TaskStatus], [StopTime]) VALUES (2, NULL, 1, N'接口资源管理', N'1，标记待删除的资源 2，清理已删除的资源', 1, 1, NULL, 0, 0, 69164886, CAST(N'2024-02-29T00:01:00.000' AS DateTime), CAST(N'2024-02-29T00:01:00.000' AS DateTime), CAST(N'2024-04-12T00:01:00.000' AS DateTime), 1, NULL)
GO
INSERT [dbo].[AutoTaskList] ([Id], [RegionId], [RpcMerId], [TaskName], [TaskShow], [TaskPriority], [BeginStep], [FailEmall], [VerNum], [IsExec], [ExecVerNum], [LastExecTime], [LastExecEndTime], [NextExecTime], [TaskStatus], [StopTime]) VALUES (3, NULL, 1, N'刷新系统配置', N'1, 触发配置系统配置项更新检查', 0, 1, NULL, 1053474441, 0, 1166520021, CAST(N'2024-04-11T21:13:30.000' AS DateTime), CAST(N'2024-04-11T21:13:30.000' AS DateTime), CAST(N'2024-04-11T21:13:40.000' AS DateTime), 1, NULL)
GO
INSERT [dbo].[AutoTaskList] ([Id], [RegionId], [RpcMerId], [TaskName], [TaskShow], [TaskPriority], [BeginStep], [FailEmall], [VerNum], [IsExec], [ExecVerNum], [LastExecTime], [LastExecEndTime], [NextExecTime], [TaskStatus], [StopTime]) VALUES (4, NULL, 1, N'清空今日访问统计', N'将今日指令访问统计数据清零', 1, 1, NULL, 597511964, 0, 0, NULL, NULL, CAST(N'2024-04-12T00:00:00.000' AS DateTime), 1, NULL)
GO
INSERT [dbo].[AutoTaskPlan] ([Id], [TaskId], [PlanTitle], [PlanShow], [PlanType], [ExecTime], [ExecRate], [ExecSpace], [SpaceType], [SpaceDay], [SpeceNum], [SpaceWeek], [DayRate], [DayTimeSpan], [DaySpaceType], [DaySpaceNum], [DayBeginSpan], [DayEndSpan], [BeginDate], [EndDate], [PlanOnlyNo], [IsEnable]) VALUES (1, 1, N'每隔2秒钟执行', NULL, 0, NULL, 0, 1, 0, NULL, NULL, NULL, 1, 10, 2, 2, 0, 86399, CAST(N'2022-01-16' AS Date), NULL, NULL, 1)
GO
INSERT [dbo].[AutoTaskPlan] ([Id], [TaskId], [PlanTitle], [PlanShow], [PlanType], [ExecTime], [ExecRate], [ExecSpace], [SpaceType], [SpaceDay], [SpeceNum], [SpaceWeek], [DayRate], [DayTimeSpan], [DaySpaceType], [DaySpaceNum], [DayBeginSpan], [DayEndSpan], [BeginDate], [EndDate], [PlanOnlyNo], [IsEnable]) VALUES (2, 2, N'每天0点1分钟执行一次', NULL, 0, NULL, 0, 1, 0, NULL, NULL, NULL, 0, 60, 2, NULL, NULL, NULL, CAST(N'2022-01-16' AS Date), NULL, NULL, 1)
GO
INSERT [dbo].[AutoTaskPlan] ([Id], [TaskId], [PlanTitle], [PlanShow], [PlanType], [ExecTime], [ExecRate], [ExecSpace], [SpaceType], [SpaceDay], [SpeceNum], [SpaceWeek], [DayRate], [DayTimeSpan], [DaySpaceType], [DaySpaceNum], [DayBeginSpan], [DayEndSpan], [BeginDate], [EndDate], [PlanOnlyNo], [IsEnable]) VALUES (3, 3, N'每隔10秒执行', NULL, 0, NULL, 0, 1, 0, NULL, NULL, NULL, 1, 10, 2, 10, 0, 86399, CAST(N'2022-10-15' AS Date), NULL, NULL, 1)
GO
INSERT [dbo].[AutoTaskPlan] ([Id], [TaskId], [PlanTitle], [PlanShow], [PlanType], [ExecTime], [ExecRate], [ExecSpace], [SpaceType], [SpaceDay], [SpeceNum], [SpaceWeek], [DayRate], [DayTimeSpan], [DaySpaceType], [DaySpaceNum], [DayBeginSpan], [DayEndSpan], [BeginDate], [EndDate], [PlanOnlyNo], [IsEnable]) VALUES (4, 4, N'每天0点执行', NULL, 0, NULL, 0, 1, 0, NULL, NULL, NULL, 0, 0, 2, NULL, NULL, NULL, CAST(N'2024-03-17' AS Date), NULL, NULL, 1)
GO
INSERT [dbo].[AutoTaskItem] ([Id], [TaskId], [ItemTitle], [ItemSort], [SendType], [SendParam], [TimeOut], [RetryNum], [FailStep], [FailNextStep], [SuccessStep], [NextStep], [LogRange], [IsSuccess], [Error], [LastExecTime]) VALUES (1, 1, N'检查超时事务', 1, 0, N'{"RpcConfig":{"SysDictate":"CheckOverTimeTran","IsReply":false,"SystemType":"sys.sync"}}', 10, 2, 1, NULL, 1, NULL, 2, 1, NULL, CAST(N'2024-04-11T21:14:00' AS SmallDateTime))
GO
INSERT [dbo].[AutoTaskItem] ([Id], [TaskId], [ItemTitle], [ItemSort], [SendType], [SendParam], [TimeOut], [RetryNum], [FailStep], [FailNextStep], [SuccessStep], [NextStep], [LogRange], [IsSuccess], [Error], [LastExecTime]) VALUES (2, 1, N'事务回滚超时检查', 2, 0, N'{"RpcConfig":{"SysDictate":"TranLockOverTime","IsReply":false,"SystemType":"sys.sync"}}', 10, 2, 1, NULL, 1, NULL, 2, 1, NULL, CAST(N'2024-04-11T21:14:00' AS SmallDateTime))
GO
INSERT [dbo].[AutoTaskItem] ([Id], [TaskId], [ItemTitle], [ItemSort], [SendType], [SendParam], [TimeOut], [RetryNum], [FailStep], [FailNextStep], [SuccessStep], [NextStep], [LogRange], [IsSuccess], [Error], [LastExecTime]) VALUES (3, 1, N'重启回滚失败的事务', 3, 0, N'{"RpcConfig":{"SysDictate":"RestartRetryTran","IsReply":false,"SystemType":"sys.sync"}}', 10, 2, 0, NULL, 0, NULL, 2, 1, NULL, CAST(N'2024-04-11T21:14:00' AS SmallDateTime))
GO
INSERT [dbo].[AutoTaskItem] ([Id], [TaskId], [ItemTitle], [ItemSort], [SendType], [SendParam], [TimeOut], [RetryNum], [FailStep], [FailNextStep], [SuccessStep], [NextStep], [LogRange], [IsSuccess], [Error], [LastExecTime]) VALUES (4, 2, N'清理已删除的资源', 2, 0, N'{"RpcConfig":{"SysDictate":"ClearResource","IsReply":false,"SystemType":"sys.sync"}}', 10, 2, 0, NULL, 0, NULL, 2, 1, NULL, CAST(N'2024-02-29T00:01:00' AS SmallDateTime))
GO
INSERT [dbo].[AutoTaskItem] ([Id], [TaskId], [ItemTitle], [ItemSort], [SendType], [SendParam], [TimeOut], [RetryNum], [FailStep], [FailNextStep], [SuccessStep], [NextStep], [LogRange], [IsSuccess], [Error], [LastExecTime]) VALUES (5, 2, N'标记待删除的资源', 1, 0, N'{"RpcConfig":{"SysDictate":"InvalidResource","IsReply":false,"SystemType":"sys.sync"}}', 10, 2, 1, NULL, 1, NULL, 2, 1, NULL, CAST(N'2024-02-29T00:01:00' AS SmallDateTime))
GO
INSERT [dbo].[AutoTaskItem] ([Id], [TaskId], [ItemTitle], [ItemSort], [SendType], [SendParam], [TimeOut], [RetryNum], [FailStep], [FailNextStep], [SuccessStep], [NextStep], [LogRange], [IsSuccess], [Error], [LastExecTime]) VALUES (6, 3, N'检查配置更新项', 1, 0, N'{"RpcConfig":{"SysDictate":"RefreshSysConfig","IsReply":false,"SystemType":"sys.sync"}}', 10, 2, 0, NULL, 0, NULL, 2, 1, N'', CAST(N'2024-04-11T21:14:00' AS SmallDateTime))
GO
INSERT [dbo].[AutoTaskItem] ([Id], [TaskId], [ItemTitle], [ItemSort], [SendType], [SendParam], [TimeOut], [RetryNum], [FailStep], [FailNextStep], [SuccessStep], [NextStep], [LogRange], [IsSuccess], [Error], [LastExecTime]) VALUES (7, 4, N'清空今日访问统计', 1, 0, N'{"RpcConfig":{"SysDictate":"ClearVisit","IsReply":false,"SystemType":"sys.sync"}}', 10, 2, 0, NULL, 0, NULL, 2, 1, NULL, NULL)
GO
SET IDENTITY_INSERT [dbo].[SystemEventConfig] ON 
GO
INSERT [dbo].[SystemEventConfig] ([Id], [EventName], [Module], [EventLevel], [EventType], [MsgTemplate], [EventConfig], [IsEnable]) VALUES (1, N'内存占用事件', N'MemoryOccupation', 1, 2, N'服务节点({server_name})已使用内存：{memory}，超过内存限制：{threshold}。', N'{"Threshold":10240,"SustainTime":5,"Interval":30}', 1)
GO
INSERT [dbo].[SystemEventConfig] ([Id], [EventName], [Module], [EventLevel], [EventType], [MsgTemplate], [EventConfig], [IsEnable]) VALUES (2, N'CPU占用事件', N'CpuBehavior', 1, 2, N'服务节点({server_name})当前CPU使用率：{rate}%，持续：{duration}。', N'{"Threshold":100,"SustainTime":10,"Interval":30}', 1)
GO
INSERT [dbo].[SystemEventConfig] ([Id], [EventName], [Module], [EventLevel], [EventType], [MsgTemplate], [EventConfig], [IsEnable]) VALUES (3, N'回复超时事件', N'RpcReplyBehavior', 1, 2, N'服务节点({server_name})回复({remote_name})指令{dicate}超时，用时：{duration}。', N'{"Threshold":5000,"RecordRange":0}', 1)
GO
INSERT [dbo].[SystemEventConfig] ([Id], [EventName], [Module], [EventLevel], [EventType], [MsgTemplate], [EventConfig], [IsEnable]) VALUES (4, N'发送超时事件', N'RpcSendBehavior', 1, 2, N'服务节点({server_name})到({remote_name})发送指令{dicate}超时，用时：{duration}。', N'{"Threshold":5000,"RecordRange":0}', 1)
GO
INSERT [dbo].[SystemEventConfig] ([Id], [EventName], [Module], [EventLevel], [EventType], [MsgTemplate], [EventConfig], [IsEnable]) VALUES (5, N'节点状态变更事件', N'RemoteStateChange', 1, 1, N'服务节点({remote_name})链接状态由：{sourcestate}变更为{newstate}。', N'{"CurState":1,"OldState":0}', 1)
GO
INSERT [dbo].[SystemEventConfig] ([Id], [EventName], [Module], [EventLevel], [EventType], [MsgTemplate], [EventConfig], [IsEnable]) VALUES (7, N'无服务事件', N'NoServerError', 1, 1, N'服务节点({server_name})向目标类型({systemtypename})发送指令{dictate}失败未找到目标服务。', N'{"SystemType":null,"Interval":10}', 1)
GO
SET IDENTITY_INSERT [dbo].[SystemEventConfig] OFF
GO
